🪴 Pauloriculture

Search

Search IconIcon to open search

[Basic] Postgres Commands (EN)

Last updated Jul 16, 2023 - Edit Source

# access to DB

1
psql postgresql://{username}:{password}@{host}:{port}/{database_name}

# get database list & choice database

1
2
\l
\c {database_name}

# get table list

1
\dt

# get table information

1
\d {table_name}

# exit

1
\q