PostgreSql command to see the table data

Question

I am new in PostgreSql. I import the database on my linux machine. I am able to see the list of tables using \d command (GSM_test_db-# \d default_msg_details) its displaying the table list but I want to see the table data.

Any Command that shows table Data also Please tell me.

I already used select query GSM_test_db-# SELECT * FROM default_msg_details but its not displaying anything and its not giving any error.

Please tell me if any command or why this select its not displaying anything.

Klaus Byskov Pedersen · Accepted Answer · 2012-02-07 14:57:48Z

23

Because you need to terminate your statement with a ;

answered Feb 7, 2012 at 14:57

Klaus Byskov Pedersen

122k31 gold badges192 silver badges223 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tryingToLearn Over a year ago

On adding ";", it gives following error message: ERROR: syntax error at or near ";" LINE 1: SELECT * FROM default_table;

tryingToLearn Over a year ago

I found the answer here. In addition to adding a semicolon, we need to turn off pagination : stackoverflow.com/questions/11180179/…

Lisa · Accepted Answer · 2015-02-19 14:23:02Z

12

Try SELECT * FROM "default_msg_details";

Beside adding ";" at the end of your query, you also need add the quotes("") to your tabel's name as well.

answered Feb 19, 2015 at 14:23

Lisa

3,0793 gold badges27 silver badges37 bronze badges

Comments

Sajjad Manal · Accepted Answer · 2019-11-19 08:53:24Z

1

Firstly, you need to disable pagination but retain the output:

\pset pager off

Then, use the below query:

SELECT * FROM "default_msg_details";

answered Nov 19, 2019 at 8:53

Sajjad Manal

3916 silver badges25 bronze badges

Collectives™ on Stack Overflow

PostgreSql command to see the table data

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related