thesuhu

PostgreSQL Commands

Jun 28th, 2020
432
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /* login root level
  2. -U: username
  3. -p: port */
  4. psql -U postgres -p 2610
  5.  
  6. /* show tables in postreSQL */
  7. SELECT
  8.     *
  9. FROM
  10.     pg_catalog.pg_tables
  11. WHERE
  12.     schemaname != 'pg_catalog'
  13. AND schemaname != 'information_schema';
Add Comment
Please, Sign In to add comment