LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 02-28-2013, 02:54 PM   #1
baronobeefdip
Senior Member
 
Registered: Jul 2009
Distribution: Debian Squeeze
Posts: 1,203

Rep: Reputation: 32
How do I show the data I inserted into a table in PostgreSQL


I have used the insert command to insert data into one of the columns in the database's table. I specified the columns and the data that was going to be placed inside of it like so
Code:
INSERT INTO table (
first column,
VALUES
(
'first column value'
);
This is a simple table with one column and only one value was added into the column, Now I want to know how to display the data I have placed into the table.
 
Old 02-28-2013, 03:21 PM   #2
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,699
Blog Entries: 54

Rep: Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962Reputation: 2962
Postgres Guide: www.postgresguide.com
 
Old 03-22-2013, 04:50 PM   #3
rnturn
Member
 
Registered: Jan 2003
Location: Illinois (Chicago area)
Distribution: Red Hat (8.0), SuSE (10.x, 11.x, 12.2, 13.2), Solaris (8-10), Tru64
Posts: 982

Rep: Reputation: 53
Quote:
Originally Posted by baronobeefdip View Post
Code:
INSERT INTO table (
first column,
VALUES
(
'first column value'
);
Is this a trick question where
Code:
select * from table;
wouldn't work?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
postgresql 8.4 Commit in Function on 3 Million Row Table mpapet Linux - Server 0 08-26-2011 01:14 AM
[SOLVED] PostgreSQL Can't Rename Table Constraints carlosinfl Linux - Server 2 04-10-2011 04:34 PM
Can't View PostgreSQL Table Data carlosinfl Linux - Server 1 12-11-2010 04:41 PM
Can't insert a record in a table on Postgresql database roqarg Linux - Server 2 09-03-2010 08:36 AM
Error when blank data CD is inserted Quercus ruber Linux - Hardware 4 03-08-2005 04:56 AM


All times are GMT -5. The time now is 11:03 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration